﻿CREATE TABLE [dbo].[Supplier] (
    [SupplierId] UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [Name]       NVARCHAR (128)   NOT NULL,
    [Address]    NVARCHAR (256)   NOT NULL,
    [IsActive]   BIT              CONSTRAINT [DF_Supplier_IsActive] DEFAULT ((1)) NOT NULL,
    CONSTRAINT [PK_Supplier] PRIMARY KEY CLUSTERED ([SupplierId] ASC)
);

